UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BAgnR0XzLb/3mV7fr+4rsa8qKuaqsLKYBo45HO/yo+Y='
WHERE
key_id = 'a000fb679e5b195e26955206728c511c9dc0c68498e5dbe9554bb5bdad2bab10'
AND (
token = 'BAgnR0XzLb/3mV7fr+4rsa8qKuaqsLKYBo45HO/yo+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)