UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYq2KmzqlQxBB8xsjhVzsTGJOhLRsC0NVnZDNt78vSc='
WHERE
key_id = '0b797c5b74a5851c55d86f4864528ef92602d66fb443ed24d91335614b00119a'
AND (
token = 'lYq2KmzqlQxBB8xsjhVzsTGJOhLRsC0NVnZDNt78vSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)