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