UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLZlRdtyB1AGACJLrnLDK8ptUVFtA+mulUube9aXMiA='
WHERE
key_id = 'df4c63bb61f9b9c71afa33f13a51d118d0a4187a5eadaf6684ca56b7c1e70c9f'
AND (
token = 'XLZlRdtyB1AGACJLrnLDK8ptUVFtA+mulUube9aXMiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)