UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NlcUEFH+D6lkDwqP9YVkay5hwjKedFgc3LhGspG5tdc='
WHERE
key_id = 'e7d8a33e6d60cb207bb8a147e660a36204610f49f53c8df02067dae1aec28d86'
AND (
token = 'NlcUEFH+D6lkDwqP9YVkay5hwjKedFgc3LhGspG5tdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)