UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EGdJkcDYN0Y7f5jSdJf8fyIedP91jElFfU/B3YA0JCo='
WHERE
key_id = '0e7674b65eacd730209e03955ace412a1eb6dad6a3c49d8f33178ef2287dd7eb'
AND (
token = 'EGdJkcDYN0Y7f5jSdJf8fyIedP91jElFfU/B3YA0JCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)