UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZK4Lae42gcGf+6d9j037xZGpbqcTkkvBviWLm7QxPIY='
WHERE
key_id = '16a728cdcd8d2a04d65712bde15c9460aeab1e60b1018d3a9f1d561ec9cbc537'
AND (
token = 'ZK4Lae42gcGf+6d9j037xZGpbqcTkkvBviWLm7QxPIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)