UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8u8247bu7uAEppjVYtIgHDOdX/yVUWn/HqaYpYNrjc='
WHERE
key_id = 'a03e272637dbb5fcc5fc9ba6853d2b34cd4358704a12b56b9102bdeab1a61ad0'
AND (
token = 'u8u8247bu7uAEppjVYtIgHDOdX/yVUWn/HqaYpYNrjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)