UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lfAtmKqUgAj2st/y6e1L2aT0ekFCQMeliTe0bnczNo='
WHERE
key_id = '0ea176b0971a108d5de43c782c3e9034e611339fa13f36c3e4892fc9906b5109'
AND (
token = '3lfAtmKqUgAj2st/y6e1L2aT0ekFCQMeliTe0bnczNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)