UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9D8vaDZGyLs72s3CfkXlyEEe5VGqn/y07icQI1uStgg='
WHERE
key_id = '5183bbc370ad1016b852d8ec82cbd9a59573eb87940e6ba274bddd244c34f37b'
AND (
token = '9D8vaDZGyLs72s3CfkXlyEEe5VGqn/y07icQI1uStgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)