UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ME27pFu0d5lnXvdQApW9ZI5ooaRN+vGGEIpKEJY8kOU='
WHERE
key_id = '44a1e18d7f38dd447f55fc38acfcebc862d93011198e025a9d42c6bd3beda282'
AND (
token = 'ME27pFu0d5lnXvdQApW9ZI5ooaRN+vGGEIpKEJY8kOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)