UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8ZOgbrvpeX1nsRkA5rrhWXMicCxD38ir7En1tIMACE='
WHERE
key_id = '6c066a62e3afa9dbf31a5f3ab5ee5f2e744a0e13e578b48dd6cb997ebff389f7'
AND (
token = 'j8ZOgbrvpeX1nsRkA5rrhWXMicCxD38ir7En1tIMACE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)