UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fKbVz9kZGAkIYD6MwoFS2mRLYToXOQYEXTkaIq/xbWE='
WHERE
key_id = 'afe92ccfb1d68d81bbe5f6fa4b26b39a53196662a2b5f62c9f3012fd36320d26'
AND (
token = 'fKbVz9kZGAkIYD6MwoFS2mRLYToXOQYEXTkaIq/xbWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)