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