UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcJIjE6NmtJmcnMTIaDliE44vKajcT6YiOJ1c4FhFfQ='
WHERE
key_id = 'c8ebac730605ef9f1ff26a7e588241793bf8c2cea3a4aa230d931954ef8edb34'
AND (
token = 'NcJIjE6NmtJmcnMTIaDliE44vKajcT6YiOJ1c4FhFfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)