UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zgk9KYBAR0iexWfIvzTr5NAdl5Z8HE6qmDKBrb/t3AA='
WHERE
key_id = '8085e16702c0f18808d3774decb20bd4fbdbb07ebf2b4b51946aceb2b84a6783'
AND (
token = 'Zgk9KYBAR0iexWfIvzTr5NAdl5Z8HE6qmDKBrb/t3AA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)