UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NVtAsfd1KlBoSx9MSqpYW9JrTrPYKO9cTo4AWrWdgk='
WHERE
key_id = 'af97bdc949c8c6baa89b0d3b4410383cb720fde7cfe2095af400908fb68609f2'
AND (
token = '2NVtAsfd1KlBoSx9MSqpYW9JrTrPYKO9cTo4AWrWdgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)