UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gr7cxmhYD4emFWxq4w2xiq/LvJbWi/p+KsI9doq0K6U='
WHERE
key_id = '0eca615eaf34c0e190f99ee76c8ca3c65759fe5de4846a12f57c20d88fa9386a'
AND (
token = 'gr7cxmhYD4emFWxq4w2xiq/LvJbWi/p+KsI9doq0K6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)