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