UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1eGL8IzCHbG/LT9aLAG6tDCJkTv1t0ZVZa46MPJBA4='
WHERE
key_id = '20a0019c2506d5775ae940227e5860d59175fb33ce24a4c731e102877190e1ec'
AND (
token = 'V1eGL8IzCHbG/LT9aLAG6tDCJkTv1t0ZVZa46MPJBA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)