UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNRqQLL0FgNKSoB+qGY2ZY9sEalxMENj0t+UZSTKXBA='
WHERE
key_id = 'bd6fef3ed935f33ef94e95f4935bc68bf9adc71ec1a56720b2e71e5b0e1fe0a7'
AND (
token = 'tNRqQLL0FgNKSoB+qGY2ZY9sEalxMENj0t+UZSTKXBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)