UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVCJC1UxXF6jXGTbq/Hi7k9gUlFzsI7qr1dEPrx1eCQ='
WHERE
key_id = 'b1edfcc13fa5fe06bc0defc7327c472e4b0a466a5c5d5a2a8111359704e6e9c9'
AND (
token = 'zVCJC1UxXF6jXGTbq/Hi7k9gUlFzsI7qr1dEPrx1eCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)