UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0U3vQ2kUghf0nCKZsVnV3yfYPYazo08Nag0JuGjIWHw='
WHERE
key_id = '5277cf83569c887a1156a563c0d3d6915218730a530d120de87a455c11fa3a74'
AND (
token = '0U3vQ2kUghf0nCKZsVnV3yfYPYazo08Nag0JuGjIWHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)