UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4hK3E/0BNro4TZ0hr3sA6Kx3s7giL+/IxOvbN05d/w='
WHERE
key_id = '9a4c6bad55999edb41fb8e4b94dd35230a624228272b16484dd4cbd7708a7542'
AND (
token = 'R4hK3E/0BNro4TZ0hr3sA6Kx3s7giL+/IxOvbN05d/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)