UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmYWEEoO5s0zV/YcSeolFfH8lhbLOsg+7eejQgRvZrw='
WHERE
key_id = '249047703dd4bb6441958da4a53e4b49df797e1af20ed9d42846128ec5af3d01'
AND (
token = 'XmYWEEoO5s0zV/YcSeolFfH8lhbLOsg+7eejQgRvZrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)