UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NocSH4ia51eUSv9BXOJRqmr23KtC5EUNdJtrDpzV8ck='
WHERE
key_id = '4e2d11e9684aaaa2c0358ca32b8955bb44ebb8f1aeaf01d87ffa341f872c1bae'
AND (
token = 'NocSH4ia51eUSv9BXOJRqmr23KtC5EUNdJtrDpzV8ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)