UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1QXIZFIFCFGMYlyiUAPOBzLAVBO+bzuhDm3w/FzecU='
WHERE
key_id = 'a5c1c292aeccd6723621ee9a1fa3a83e142ae09481d5d1d3d6185bcfe05b7563'
AND (
token = 'a1QXIZFIFCFGMYlyiUAPOBzLAVBO+bzuhDm3w/FzecU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)