UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LadKHymKiNcWK0+NhVFb9+hGRdsLpokI3DZEHA/NHwQ='
WHERE
key_id = '7e81b0717272c9d9464a7039cf45c1ac0245ad3f06df13147da64eb601a2de20'
AND (
token = 'LadKHymKiNcWK0+NhVFb9+hGRdsLpokI3DZEHA/NHwQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)