UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RtWpmahGr0ktmWZlhH0N2/GNYdJ6BsIFe+NCybwBh4='
WHERE
key_id = 'e1db58dd5e98694ebe982bffe672df188deeada123abe7b67025374ececb503a'
AND (
token = '8RtWpmahGr0ktmWZlhH0N2/GNYdJ6BsIFe+NCybwBh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)