UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hm69Kt8xuH4zVWyGxiaMZ+zwe/TL0I8WzriuWmiM4/A='
WHERE
key_id = '31f9609818d538417e1220e0cbf4f54cc8fcc5246f52418b2b65723053ff7782'
AND (
token = 'Hm69Kt8xuH4zVWyGxiaMZ+zwe/TL0I8WzriuWmiM4/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)