UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zq/vX8Dh8bcaHINkBp/bvxFYQwbsfKfuOXDpBu+1xCQ='
WHERE
key_id = '40ea7f2d5502cc479c4ed21a611412be293352d72312b63ef651a2ad242501cb'
AND (
token = 'zq/vX8Dh8bcaHINkBp/bvxFYQwbsfKfuOXDpBu+1xCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)