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