UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBstwyxn5hJNa3BLU8tSjVgcLfK4xj98nPmMrZ7JR74='
WHERE
key_id = '744cee2b7227c4efb0bab87d5d1b5f0f21f96bbdd01824ac81b6921b2ffb5ef7'
AND (
token = 'KBstwyxn5hJNa3BLU8tSjVgcLfK4xj98nPmMrZ7JR74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)